1999A Meta-Data Management System for Data Warehouse
نویسندگان
چکیده
A data warehouse is simply a single, complete, and consistent store of data obtain from a variety of sources and made available to end users in a way they can understand and use in a business context. To manage and maintain the heterogeneous data source and huge amount data of a data warehouse, much research has been done in the topic called Meta-Data management system. Current research for Meta-Data management systems is focused on the management of the heterogeneous database schema but not system performance. This paper describes a new Meta-Data management system architecture, which is focused on the uniform Meta-Data model and the query performance. The new system includes a repository to store an integrated database schema which is constructed from the different source database schema and a proxy database server which is to store used data by following the structure of the integrated database schema. This new architecture can increase the query performance and reduce the loading to manage the huge amount data for a data warehouse.
منابع مشابه
ارائه مدل تلفیقی برای ارزیابی آمادگی سازمان ها جهت پیاده سازی سیستم انباره داده با استفاده ازتحلیل سلسله مراتبی
Enterprise Data Warehouse initiative is a high investment project. The adoption of Data Warehouse will be significantly different depending upon the level of readiness of an organization. Before implementation of Data Warehouse system in a firm, it is necessary to evaluate the level of the readiness of firm. A successful Data Warehouse assessment model requires a deep understanding of opportuni...
متن کاملMetadatenverwaltung zur qualitätsorientierten Informationslogistik in Data-Warehouse-Systemen
The goal of a data warehouse system is to provide a comprehensive overview of the data available in a company, thereby supporting the management decisions. The integration of data coming from heterogeneous sources is one of the key problems in data warehousing. The technical foundations for the integration have been developed in recent years. However, an efficient technical infrastructure is no...
متن کاملDesign and Analysis of Quality Information for Data Warehouses
Data warehouses are complex systems that have to deliver highly-aggregated, high quality data from heterogeneous sources to decision makers. Due to the dynamic change in the requirements and the environment, data warehouse system rely on meta databases to control their operation and to aid their evolution. In this paper, we present an approach to assess the quality of the data warehouse via a s...
متن کاملA Solution to View Management to Build a Data Warehouse
Several techniques exist to select and materialize a proper set of data in a suitable structure that manage the queries submitted to the online analytical processing systems. These techniques are called view management techniques, which consist of three research areas: 1) view selection to materialize, 2) query processing and rewriting using the materialized views, and 3) maintaining materializ...
متن کاملGraMMi: Using a Standard Repository Management System to Build a Generic Graphical Modeling Tool
Commercial off-the-shelf repository management systems claim to provide a solid basis for building CASE tools by offering special meta-data management facilities (like versioning, configuration management, long transactions support). Another important area of application for these systems is the management of meta-data in data warehouse environments. The ISO-IRDS standard defines a framework fo...
متن کامل